oracle tsn

ORACLE space management experiment 1: exploring the structure of the data file header under LMT tablespace management and the record directory (?) in the bitmap Area (?) [] The experiment is divided into two steps: 1. the local tablespace managed by

The experiment is divided into two steps:1. Local tablespace managed by LMT. Structure Analysis of data files during Automatic ASSM segment ManagementORACLE 11G: 0 operating system block, 1-2 is the file header, 3-is the bitmap information. Data is

I. Introduction of row migration and row link in actual work we often encounter some problems with low Oracle database performance. Of course, there are many reasons that cause low Oracle database performance, we can use some correct design and

Functions of L1, L2, and L3 blocks:-facilitates the query of data blocks. L3 has pointers to L2, L2 has pointers to L1, and L1 has pointers and statuses of multiple data blocks. 1. Each L3 contains multiple L2 addresses (the first L3 is the segment

A friend's company's database encountered an exception and there was no backup. After the database is opened, crash will be quickly cleared. The following alert log information:Tue Jul 08 22:53:03 2014SMON: enabling cache recovery[2, 13803]

Environment: SQL> select * from v$version where rownum=1;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdSQL> !uname -aLinux localhost.localdomain

In the actual work we often encounter some Oracle database performance is low, of course, the reasons for the low performance of Oracle database is various, we can through some correct design and diagnosis to try to avoid some Oracle database

Customer database exception (ORA-600 kcbz_check_objd_typ_1), let's remotely handle the analysisORA-600 kcbz_check_objd_typ_1 exceptionMon Aug 8 12:19:28 2016Completed: ALTER DATABASE OPENMon Aug 8 12:19:29 2016Db_recovery_file_dest_size of 20480 MB

A customer's 11203 rac (asm) power loss the day before yesterday caused the database to fail to start. Note that the database is in archive mode. We can see how unlucky it is.According to colleagues, the startup failed due to damage to the redo and

A system has been killed frequently recently. The symptom is that all the CPU resources of the system are exhausted. The system environment is as follows: Dual CPU and RAID 5Oracle 8.1.7.0.1Weblogic 1, 8.12JAVA JDBCOracle and weblogic run on RedHat 7